If you want to avoid VBA, the following formulas could work for you: =LEFT(A2,FIND(B2,A2)-2) =RIGHT(A2,LEN(A2)-FIND(B2,A2)+1). ... <看更多>
Search
Search
If you want to avoid VBA, the following formulas could work for you: =LEFT(A2,FIND(B2,A2)-2) =RIGHT(A2,LEN(A2)-FIND(B2,A2)+1). ... <看更多>